SUPPORT / SAMPLES & SAS NOTES
Problem Note 52804: SAS® Web Report Studio might return a syntax error when you generate a report that includes totals and multiple hierarchies
 |  |  |  |  |
When SAS Web Report Studio reports that are based on an OLAP data source include totals or percent of totals and multiple hierarchies, an error similar to the following might occur:
Found {, expecting ), ',',NOTOTALS, NOTOTALS_POST, POST, SUBTOTALS, SUBTOTALS_POST, TOTALS, TOTALS_POST.
This error is most likely to occur if the following conditions are true:
- The report includes fractions of totals.
- The totals are on the same axis as the measures, and the measures are on top.
- More than one hierarchy is represented in the results.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Web Report Studio | z/OS | 4.31 | 4.4 | 9.3 TS1M0 | 9.4 TS1M0 |
| Microsoft® Windows® for x64 | 4.31 | 4.4 | 9.3 TS1M0 | 9.4 TS1M0 | ||
| 64-bit Enabled AIX | 4.31 | 4.4 | 9.3 TS1M0 | 9.4 TS1M0 | ||
| 64-bit Enabled Solaris | 4.31 | 4.4 | 9.3 TS1M0 | 9.4 TS1M0 | ||
| HP-UX IPF | 4.31 | 4.4 | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Linux for x64 | 4.31 | 4.4 | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Solaris for x64 | 4.31 | 4.4 | 9.3 TS1M0 | 9.4 TS1M0 | ||